Labels:book | chat room | hakham | monitor | sky OCR: DATABASES 637 Another technique that prevents typographical and case sensitivity errors is FIGURE 11-36 to limit data entry to the items on specified list. For example, the state Clickable lists are an easy way abbreviation for Michigan might be entered as MI, Mi Mich, or NI if your fin- for users to enter data in gers slipped However most databases allow the database designer to standard format specify list of acceptable entries for each field. Most people are familiar Select State with clickable lists of states such as the one in Figure 11-36. Select State Database designers can also prevent entry errors by using lookup routines. Alaska Alabam lookup routine validates an entry by searching for the same data file Arizona or database table For example suppose that Vintage Music Shop Califo ...
